\i /home/the-best-goose/workspace/DB/lab_5/drop_views.sql
drop table many_employee_has_many_degree;
drop table many_employee_has_many_lesson;
drop table many_employee_has_many_positions_at_many_departments;
drop table many_faculty_has_many_department;
drop table many_lesson_has_many_group;
drop table many_subject_has_many_check;
drop table lesson;
drop table study_area CASCADE;
drop table "group" CASCADE;
drop table subject CASCADE;
drop table "check";
drop table employee;
drop table position;
drop table department;
drop table degree;
drop table faculty CASCADE;
drop table lesson_type;
drop table person;
drop table room;
drop table base_institution;
drop sequence subject_id_seq;
drop sequence room_id_seq;
drop sequence position_id_seq;
drop sequence group_id_seq;
drop sequence lesson_id_seq;
drop sequence faculty_id_seq;
drop sequence department_id_seq;
drop sequence person_id_seq;
drop sequence employee_id_seq;
drop sequence type_id_seq;
drop sequence area_id_seq;
drop sequence base_id_seq;
drop sequence check_id_seq;
drop sequence degree_id_seq;
